
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_SearchNotice]
    (
      @param_JOL_Bulletin_Title VARCHAR(100),
      @param_JOL_Bulletin_Type VARCHAR(50),
      @param_JOL_Bulletin_SubType VARCHAR(50)
    )
AS 
    SELECT  JOL_Bulletin_No,
            JOL_Bulletin_Title
    FROM    dbo.JOL_Bulletin
    WHERE   JOL_Bulletin_Title LIKE '%' + @param_JOL_Bulletin_Title + '%' AND JOL_Bulletin_Type=@param_JOL_Bulletin_Type AND JOL_Bulletin_SubType=@param_JOL_Bulletin_SubType
    ORDER BY JOL_Bulletin_IsSetTop DESC,
            JOL_Bulletin_AddTime DESC,
            JOL_Bulletin_UpdateTime DESC
GO
